package com.dnjn.happiness.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dnjn.happiness.system.domain.SysSite;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * <p>
 * 站点 二级部门单拉出来做站点 Mapper 接口
 * </p>
 *
 * @author Amber
 * @since 2023-10-05
 */
public interface SysSiteMapper extends BaseMapper<SysSite> {

    void deleteSite(Long siteId);

//    @Select("SELECT s.site_id,s.site_name,s.number_of_people,h.avg_score,h.curr_date currDate FROM sys_site s LEFT JOIN emo_team_avg_score_history h ON h.dept_id = s.dept_id WHERE " +
//            "h.curr_date BETWEEN #{startTime} AND #{endTime} GROUP BY s.site_name,h.curr_date ORDER BY h.curr_date")
    List<SysSite> siteAvgScore(@Param("startTime")String startTime, @Param("endTime")String endTime);
}
